Evaluation of Developed Macro-enabled Spreadsheets and ZipGrade in Automating Paperwork of Teachers

AUTHOR(S)

RONNIE C. GONZALES, MAT

ABSTRACT

— This paper aimed to evaluate the developed macro-enabled spreadsheets and ZipGrade in automating paperwork of teachers in Southville 8B National High School in the School Year 2022-2023. ZipGrade is a paid application that could be used in the administration of formative and summative test. The shaded answer sheets of the students could be checked by scanning them using camera of smart phones. The generated results of the test in ZipGrade have compatibility with Microsoft Excel. The macro-enabled spreadsheets were developed using VBA, the programming language of Microsoft Excel. These electronic templates can generate and print the needed data in analysis of test and report cards. The result showed that the two groups of respondents, teachers with 6 years and below tenure and teachers with above 6 years tenure, evaluated the developed Macro-enabled spreadsheets and ZipGrade and strongly agree in terms of usability, maintainability, compatibility, format, accuracy, and productivity. There was also no significant difference between the evaluations of the two groups of respondents which implied that the developed Macro-enabled spreadsheets and ZipGrade were accepted by the two groups of respondents and could be used for the automation of paperwork of teachers.